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

  1. Need help in collating data from multiple excel files
  2. Solved: Delete Cell Content based on criteria
  3. Solved: Excell crashing for apparently no good reason
  4. Find, Copy Text from Word and paste in excel
  5. Hide the form on a worksheet
  6. Macro/VBA Beginner-HELP!!
  7. Subract last cell from above
  8. Check Word, Powerpoint and Excel files for embedded objects
  9. Errors all over the place!!!
  10. Allowing user to select range of columns for comparison
  11. Move the mouse cursor in the top left corner of the selected cell.
  12. Solved: launching a shell command silently from within VBA
  13. Add user edit range
  14. Solved: My code start to be slow.
  15. Need help to insert column in Pivot
  16. Function, compile error.
  17. Solved: Need help regarding formatting sting using VBA
  18. Solved: Importing data from other Excel spreadsheets
  19. Solved: Cant get the value of a control in a multipage
  20. HELP to show formula
  21. Solved: Running Module from Other Workbook
  22. VBA Code to Hide Blanks in Pivot Table
  23. Solved: Time Stamp in cells using VBA
  24. Copy function
  25. VBA HELP
  26. VBA lookup and delte
  27. Delteing
  28. How to insert Japanese character to SAP from Excel?
  29. Using VBA to disable Save and Save As
  30. Dynamic Range Transpose Loop
  31. Solved: Excel 2003 Saveas Issue
  32. microsoft ado control & datagrid6
  33. VLOOKUP Between workbooks
  34. Need help with select case structure
  35. Help to a code - Save as - Debug
  36. Solved: Date, Month, and Time Stamp using VBA
  37. How to sort files before inserting to worksheet
  38. Solved: long function from excel to vba
  39. How to call\use DLL via vba macro?
  40. Solved: Find Text
  41. Formatting strings in cells
  42. RunTimeerror 2147417848 (80010108) Object invoked disconnected from its clients
  43. Refernce formula and formatting
  44. Linking macros to hyperlinks in VB
  45. Solved: Multiple IF statement (??)
  46. Save dialog in ppt
  47. Asking about VBA in Excel
  48. I need a Worksheet_Change macro moving cell to cell
  49. Code to Compare Cell Contents
  50. Solved: Is there a way of shortening my ever increasing vba
  51. If any column in active worksheet is hidden, then the value of cell A1 is “hide”.
  52. Solved: Range.Find returning Nothing
  53. Help with a macro
  54. Help with multiple criteria functions or VBA code.
  55. Remove Last Row Value From Sort
  56. Solved: Copy and Paste On Formula Result
  57. Solved: Copy a Range then Transpose Paste into every other Cell
  58. Export worksheet problem with path
  59. for loop returning 2 numbers
  60. Solved: Help uderstanding this loop
  61. Solved: Hex to Binary conversion, not using HEX2BIN
  62. Solved: separate specific symbols in order of priority
  63. Solved: Create chart on new sheet using VBA
  64. Is querying beyond 255 columns dead?
  65. Solved: placing formula in the same cell (D7) of all tabs
  66. Re arrange columns from selected rows
  67. Auto Start/Stop Macro at specific times
  68. Solved: Macro to remove entire if null value encounter in column
  69. VBA CODE ADD TO CODE MANDATORY CELL
  70. Worksheet_SelectionChange(ByVal Target As Range)
  71. Simulate mouse movements
  72. dynamic x axis "find last cell" vba code
  73. Extract Values of SN tags and save to Excel
  74. Solved: .FormulaR1C1 VBA
  75. Display tiff image on vba form
  76. Double click can edition in ListView
  77. CostCenter and Product combinations
  78. Context Menu on UserForm
  79. mail from excel
  80. Solved: VBA Code : Help required
  81. VBA FORCE CELL NOT WORKING
  82. Excel DLL CUDA
  83. Link UserForm with worksheet data
  84. Solved: Used Range Selective ClearFormat
  85. Resize Chart as Picture
  86. New Workbook for each worksheet
  87. Test if variable or object exists
  88. reload job nos fron jobs at J status
  89. Date Time copy paste not including time
  90. Solved: Need help for conversion
  91. Extract Web Page Data
  92. Solved: Copy data with values & paste in another worksheet
  93. Solved: Loop Until Help
  94. using excel to fill online form
  95. Copy worksheet cells from sub folders to new workbook
  96. Excel macro/VBA to sort a column, upload to sharepoint and save as draft on outlook
  97. Summarising of info from many w/sheets with a Macro
  98. Removing Spaces
  99. Solved: Repeat cells N Times
  100. An MSForms Treeview
  101. Solved: VBA to delete a row in another worksheet
  102. Solved: Subfolders's names in array
  103. Solved: If cell is cleared or blank the conditional formating color is removed
  104. Solved: Draw without repeating words until the entire list has been drawn
  105. Solved: Help with Find/Delete Entire Row
  106. Solved: Incorrect VBA Sort on Workbook Close
  107. Problem Using Kill File
  108. How to get records in excel ADO
  109. Solved: Add date to Userform
  110. Solved: Help with automatically fill in cells by VBA loops
  111. Solved: Excel- align rows by column. Works but too slow!
  112. Solved: Worksheet Change Function: Created WS?
  113. Solved: Return a value from another sheet
  114. Solved: Remove Freeze Panes From Inactive Window
  115. Solved: Byref argument type mismatch array
  116. Excel Automation of IE - help click this button
  117. Solved: Double Click Event for Shapes
  118. Use a list from Excel to move files on computer
  119. Can not get rid of "Do you want to Save changes"
  120. Multiple currency format from UserForm
  121. VBA - CELL VALUES EXCEED 12 (MONTHS)
  122. Solved: Add third column to listbox
  123. Solved: sort columns dynamic
  124. vba to find and replace exact matches of cell value in a sheet
  125. Solved: user name
  126. Solved: Type mismatch error on If Not Range...
  127. Multiple Criteria Lookup
  128. group and hide blank space
  129. Special Sort needed - Sorting labels contained in one column
  130. Disappearing calc field in pivot table
  131. Solved: change name tab office
  132. Solved: Function that's not working as should
  133. Attachment to gmail
  134. Solved: cell checking
  135. VBA - Macro to create/update documents in Lotus Notes database
  136. Export Selected Sheets to New workbook
  137. Running Macro Automatically if a cell value is True.
  138. Runtime err 1004
  139. OFFSET of result from vlookup
  140. datestamp on cell CHANGE
  141. Excel vba script to insert data into Outlook
  142. Multiple conditional values from Excel in VBA listbox
  143. Opening a new file of a different format
  144. [SOLVED] Excel chart - identify the selected data point through macro.
  145. VBA Excel HTML e-mail?
  146. pivot vba
  147. data send to zohosheet
  148. Capture window help
  149. Solved: Sort All sheets in a workbook
  150. VBA Show All Data
  151. CONDITIONAL FORMULA with Percentage
  152. execute macro if change to range
  153. Text Box, text formatting
  154. conditional formatting text conditions
  155. Line list box
  156. RunTime error 462 - The remote Server machine does not exist.
  157. Muti Solver VBA
  158. Remove gaps in a combobox list
  159. Solved: Use a spreadsheet specifies interval even if another is active
  160. Embedded gif in userform
  161. Solved: EASY VBA ISSUE TO FINALIZE THE IMPLEMENTATION OF THE MERSEENE TWISTER RNG
  162. Merseene Twister VBA app easy issue to solve (with zip file)
  163. Compile error: Expected line number or label or statement or end of statement?
  164. Solved: Getwindowstext and settext
  165. Help with code to copy to another worksheet
  166. Consolidate data from different excel files (VBA)
  167. Solved: Make folder path and file name with VBA code
  168. Solved: Refresh my pivot table
  169. search folder structure and return paths only
  170. Solved: Application or object based error
  171. Paste special data till last updated row
  172. Solved: Smallest 3 numbers in range
  173. Class Modules in AddIn .xlam
  174. Save As Query
  175. VBA Form that uses data from a worksheet
  176. Solved: copy from excel to word unmerged table
  177. Solved: Empty Cells Will Not Delete
  178. Solved: VBA Pogress Bar
  179. code created text box not firing change event
  180. ContextMenu example errors
  181. repeated user input
  182. how to get profit as per fifo method
  183. Simple VBA Statement
  184. Macro to fill values of row numbers in a 10x20 grid
  185. Using HLookup
  186. Solved: New procedure at end of code?
  187. Solved: Insert header rows
  188. Help with Sorting by first name
  189. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change)
  190. Solved: countif? within a loop
  191. PIVOT table - Change sub column label
  192. HELP, user-defined type not defined
  193. Solved: Getting average of a range within a loop
  194. Get last row of a page
  195. Unexpected "Subscription out of range" error
  196. Creating Summary/ VBA code
  197. Solved: Fetching data from excel
  198. Passing Array Issues
  199. Solved: If statement
  200. Solved: worksheet tab options unintentionally disabled
  201. Excel 2003 User Defined Function
  202. Solved: need help with finding the minimum in a 1D array
  203. Solved: Array Formula Question
  204. Select an item from a website tree
  205. Solved: Macro Equation
  206. Solved: Remove certain charachters from a cell
  207. adAsyncExecute apparently gets cut off
  208. Protecting Cells With A Password In different Work Sheets With Code?
  209. Treeview in 2010 64Bit
  210. Solved: copy entire row to new sheet along with header
  211. Run Time Error '76' - Path Not Found
  212. Solved: Show All Data From Two Columns Matching Todays Date In A Msgbox
  213. Solved: Status Bar Message With Extract Macro
  214. Solved: Making a macro compatible among multiple users
  215. Solved: Show the working days without holidays
  216. Add signature to email
  217. Copying and Paste files
  218. Solved: Error while printing pdf from excel
  219. Solved: Change the place of alphabets to numeric
  220. [SOLVED] VBA code for pivot filtering
  221. VBA Prevent File From Saving
  222. Solved: Working with String in VBA
  223. Solved: Popularize Listbox using Textbox
  224. Programming for the null case
  225. Find the Max Value when a cell contain Text and Number
  226. Solved: VBA to remove duplicates as per the date
  227. Solved: Matrix Multiplication of Arrays
  228. Displaying Search Results
  229. Solved: Change selected cells to common range
  230. Solved: Sorting data problem...need to sort at midpoint of data table
  231. Read Excel using SQL Statements
  232. Generate HTML email with file attached - please help
  233. Clearing Auto-Filter with Password Protection on
  234. Solved: Macro not working properly
  235. Solved: OLEObject Vlookup help
  236. Userforms, Listboxes, Virtual space.
  237. Add-in file path Excel 2000?
  238. Help with crating a tab based on cell value
  239. Solved: Setting Pivot Table Filter with VBA
  240. Solved: How to use VBA to test if a number is a prime or not?
  241. help with Payroll employees
  242. Solved: file name via function
  243. Saving the return value of oracle function in a string
  244. Count unique values based on another column
  245. Putting Values of 3 columns into one column using If ElseIf statements
  246. VBA to delete multiple rows based on multiple criteria?
  247. VBA Or Macro: To format data in a column and delete columns and create new column
  248. Compare one column with one cel and input result on a second column
  249. Solved: Obtain Pivot Table Cell properties with VBA
  250. set color saturation of image with vba