PDA

View Full Version : Excel Help


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 [108] 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
  1. Excel Page Format-help pls.
  2. Worksheet Security based on Windows ID
  3. Auto-filter turning off in protected worksheet
  4. Find Times Greater than Time Entered
  5. [SLEEPER:] Retrieve Values through an RS232 Connection
  6. [SOLVED:] Setting Pivot Chart height at pivot table refresh
  7. Macro for hidding and unhidding sheets
  8. Solved: how to copy range and paste in same range in another workbook
  9. Pop Up Message Keeps popping up
  10. [SOLVED:] Application or Object defined error
  11. Solved: populate with range from another sheet
  12. Find the Double ID
  13. Closed workbook and extract sheet by cell value
  14. Solved: msgbox displaying new workbook object path
  15. Conditional formatting according to range
  16. Retreiving the properties out of a class.
  17. fill Combo box data acroding to text box data entry.
  18. Solved: Loop Help
  19. Multiple LIKE operators?
  20. Solved: help getting listindex from listbox
  21. Open Workbook transfer info then close workbook (2007)
  22. [SOLVED:] Many urgent excel at vertical instead of horizontal word
  23. Compare two worksheets and give the difference as result
  24. Input box to select sheet then rename sheet
  25. To get in Excel the URL of the opened Webpage ?
  26. Array raising each element to a power - please help!
  27. [SOLVED:] Split Data in one cell into below rows
  28. Copying and pasting cells from Excel to a fillable PDF file
  29. Sort duplicates on top
  30. Help getting script to exit if cell is blank
  31. Solved: Dynamically setting a dropdown dependant upon cell value
  32. VBA with PI Datalink
  33. Macro doesn’t work after a table is created.
  34. To paste in Word the selected text in webpage by an Excel macro
  35. Adding MMM-YY to filename
  36. Combine multiple rows into one and then seprate specific columns
  37. Solved: VBA Copy a template sheet and paste it into multiple sheets
  38. Something odd has happened with an "Always on Top" window.
  39. [SOLVED:] 3 cells USERFORM to enroll in one cell in excel
  40. Solved: Converting the VB code to VBA.
  41. Total values associated with unique value in adjacent column
  42. VBA HELP! - Need slight change to my code
  43. VBA pivot with no range
  44. Drop Down List to Copy Contents of Another Column into a Certain Column
  45. VBA Help - Desk sharing solution - thanks in advance
  46. How to post sample excel data
  47. Solved: run macro from one workbok to affect other workbook
  48. Solved: code running too fast?
  49. Change Dropdown Macro
  50. Find all hard coded references
  51. Master Directory Search (Needs A Tweak)
  52. VBA from Excel to Outlook 2010 help
  53. Solved: CAGR formula using only range as input
  54. Synchronizing Multiple Worksheets
  55. Solved: function to find the number of iterations/loops Do...Loop
  56. Solved: Dynamically populate combobox in userform
  57. Accessing files in order of Date Last modified
  58. Solved: Loop through multiple sheets and delete rows based on a cell reference
  59. Project locked for viewing - SendKeys?
  60. Excel 2 XML using Macro
  61. Macro is getting Runtime error 91 - why?
  62. Macro Triggers Unreadable Content Error on Restart
  63. Sleeper: Macro loop issues
  64. Solved: Detecting Last Time File Was Opened
  65. Solved: Opening and writing to multiple ASCII text files
  66. find closest date
  67. Solved: Calculate Distribution
  68. Save as xlsm function
  69. Getting Application defined error 1004 for vba
  70. FileSystemObject create file containing text copied from IE
  71. Solved: Stop watch in excel which just displays minutes
  72. Insert and Delete Rows in Entire Workbook
  73. Reference across sheets
  74. Worksheet on change code a bit slow
  75. Can somebody help to achieve following tasks?
  76. Solved: Command Button (Save as PDF)
  77. How to copy an active Excel worksheet to another excel file?
  78. Using conditional formatting
  79. getting the row numbers of visible rows in an filtered selection
  80. simple auto macro :)
  81. Copying sheets into new workbook
  82. How to create a sequence of dates?
  83. VB disable conditional formatting code
  84. [SOLVED:] Determining the 2nd highest number in a list
  85. Solved: update pivot tables based on the value of cell 'C2'
  86. Real Time Clock in a Textbox on a Userform
  87. alphanumerics only
  88. Macro to import entire text file into single cell
  89. Simple Merge of two lists/tables
  90. [SOLVED:] Index/Match VBA equivalent to append data
  91. Solved: How to suppress replacing cells when using PasteSpecial?
  92. Solved: Populate hyphen for continuous three or more zero in a row
  93. [SLEEPER:] vba program
  94. [SOLVED:] Delete Duplicate Values only... Not rows
  95. Solved: Creating a dynamic user defined function
  96. Filter a sheet and copy results to another sheet
  97. date range and return value
  98. Solved: Fill an array with vlookup vba
  99. shade header row
  100. Conditional Formatting - Change font
  101. Paste onto filtered cells
  102. Solved: VBA Interaction with IE
  103. modify macro with hyperlink
  104. Moving Files Based on Last Modified Date
  105. Solved: Creating a dynamic concatenation from a list
  106. What is the code to open access file
  107. Troubleshoot an Overflow Error
  108. Sleeper: Passing transformed arguments to UDF
  109. Solved: Automatically Update date in cell value if workbook is saved under a different name.
  110. MyCheck Fuction
  111. Sumdata based on a table of possible criteria
  112. Solved: error with mouse_down
  113. How to enumerate a variant array?
  114. Excel WB painfully slow
  115. Solved: Error found in codes given in KB
  116. Solved: Copy From Multiple Files To One
  117. Solved: Email active worksheet using Outlook
  118. GOBACK subroutine for Excel 2007
  119. Solved: Identifying Duplicates Prior to Data Entry.
  120. Solved: Copy, Open, Paste
  121. Solved: Add Hairline Border Via Vb
  122. Excel using Loop
  123. Solved: VBA table summarize
  124. Populate Two Text Box using input value
  125. 'Partial' Julian Date Issue
  126. Windows Explorer Shortcut Link Generator
  127. Conditional Format On Specific Range
  128. Filtered Cells Problem
  129. Remove last few characters from a string
  130. xmlHttp get requst - cannot get past login
  131. How to control an Excel file without opening it?
  132. XML Integration
  133. Solved: Locate Date in cell formatted as DD-MMM
  134. FileName
  135. "method range of object _worksheet failed" Error
  136. get data from word form into excel using macro
  137. Solved: creating multiple xltx templates
  138. Formula to pull formula from another cell
  139. Solved: insert row if match is missing in column above
  140. Solved: Populating Textbox 2 on the basis of Textbox 1
  141. MACRO help to delete some files in a particular folder
  142. Login and Password for user form
  143. Create Workbooks based on Unique Values from a Column
  144. Code running amazing slow when file is shared
  145. Loop? Copy/Paste from to Summary from Workbooks on Server
  146. [SOLVED:] Find Question
  147. Search Functionality that moves cursor
  148. Solved: Hide Rows...help in code
  149. Concatenate (Nest) "IF" Commands ??
  150. Syntax for Set_Cursor_Pos()
  151. [SLEEPER:] Search Worksheet for Name if found copy to new workbook
  152. Compare data between two workbooks
  153. Excel code to open Access!
  154. Source workbook keeps opening when Destination workbook is protected?
  155. Need to increase the percentage in a cell containing the original value
  156. Storing Variable From One Cell And Printing It Repetitively In Another Column
  157. Solved: Change color figures, with discretion
  158. Thematic Map
  159. show username if file is open
  160. Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest
  161. Loop through rows and delete/keep
  162. Printing Unique Values (From a column) in a Combobox
  163. Modify Cut Paste
  164. Help with concatrelated vba excel
  165. Printing issue
  166. Solved: cut and pasted into Sheet2
  167. A Combo Box for Certain Types of Information from another worksheet??
  168. Solved: Copy Range If Cell Value Equals
  169. Highlight the last selected cell
  170. Solved: Problem in creating status bar
  171. VBA functionality for String manipulation
  172. use date stamp to trigger Shift:=xlDown?
  173. Calculation On/OFF Basis On Selection
  174. Sum amounts based on another column
  175. [SOLVED:] Select the shape as shape variable
  176. How to solve excel compatibility?
  177. Solved: Do something every 14 minutes
  178. Solved: VBA Formatting mess of text
  179. [SOLVED:] Open Notepad and write something onto it
  180. Passing an Object to a Function
  181. auto save and close workbook after 15 minutes of inactivity
  182. Loop filter and copy
  183. Getting data from Word Controls into Excel
  184. Solved: SumProduct RowsandColumns
  185. Populating IP Address & Username of the user in Excel
  186. Question on ActiveWorkbook.Calculate
  187. Copying range to variant
  188. Solved: Runtime error '13', Type Mismatch
  189. Formatting excel sheet
  190. Disable File Save And Highlight Empty Cells
  191. Solved: automatic FormulaCalculation Option using VBA
  192. Help VBA code for calculating time difference
  193. Solved: vary column
  194. Nested loops and populating a new ws with the items
  195. Merging two or more files, column by column
  196. Compare two worksheet current code modification
  197. auto Email
  198. Data transfer based on certain findings
  199. editing text in a cell
  200. Send Excel Body by Outlook
  201. Excel VBA Error 445 in 2007/10 but 2003 is fine
  202. Same number of trades
  203. Count members of AD group from Excel
  204. Play Sound in Excel
  205. Highlighting particular cells
  206. Solved: Workbook Slowdown
  207. Plotting to PDF
  208. Sort Values In Array
  209. [SOLVED:] File Renaming Tool - Working in Subfolders
  210. Solved: Change in Path to Server - Query Macros Affected
  211. Sine Wave Audio Sound Generator
  212. Solved: Pivot Date Filter between variable number of days
  213. Problem with keeping the year end dates of downloaded financial data
  214. Solved: Locking a Row Question
  215. Nested IF Function not working when the first condition is False
  216. Help please want to write string sorting function
  217. Solved: count, insert, copy, paste rows from one worksheet to another
  218. Application.MacroOptions: StatusBar property not working
  219. Need help on MultiPage control
  220. Solved: Advice and Help which database to use
  221. combine all file in a one workbook
  222. Excel 2007
  223. Read/Write Userform to variable range of cells
  224. Highlight the selected cell
  225. Private Sub : copy formula
  226. Madness - Excel Crashing
  227. If Statement checking
  228. Searching multiple workbooks for hidden content
  229. Solved: Copy B4 value of each guide based on column A of worksheet "Plan2"
  230. Solved: Copy and Paste Row if Cell Has Value
  231. Filter : date after 15 /10/2012
  232. excel pivot table problem
  233. Code doesn't send in email
  234. VBA merge from some open and some closed workbooks
  235. Selecting 2 Cells to the right of the ActiveCell
  236. Copying Excel range to Word doesn't copy the image
  237. Solved: Inserting data into the column and maintain it locked
  238. Scroll to a named macro in the VBE
  239. Solved: Dynamic array in VBA of newly added worksheets
  240. Solved: Vba code to clear data cells only not those with formula
  241. Add value, as seconds, to LongDate
  242. Generating Custom Report thru VBA
  243. Solved: Copy formula automatically & Paste valuse :VBA code error Rectification
  244. vba workbook_sheetchange event for xlam thisworkbook
  245. Run HLOOKUP macro on outcome of Data Validation
  246. Application defined or Object defined error
  247. Choose range
  248. Solved: Track Cell Value Change
  249. 430 Error when Macro Run
  250. Solved: Operate with data from txt file